//
//  Unsung.m
//  AoA
//
//  Created by abaca on 2010/9/6.
//  Copyright 2010 __MyCompanyName__. All rights reserved.
//

#import "Unsung.h"
#import "Voice.h"
#import "Tryit.h"

#include <sqlite3.h>

@implementation Unsung


#pragma mark -
#pragma mark Database

-(void) initDB {
	
	theShows = [[NSMutableArray alloc] init];
	
	char			*sqlStmt;
	sqlite3			*db;
	char			*dbName;
	sqlite3_stmt	*stmt;
	
	const char *sql = "select * from menu";
	dbName = (char *)[[[NSBundle mainBundle] pathForResource:@"mydatabase" ofType:@"sqlite"] UTF8String];
	
	if (sqlite3_open(dbName, &db)==SQLITE_OK) {
		
		sqlStmt = sqlite3_mprintf(sql);
		
		
		if (sqlite3_prepare_v2(db, sqlStmt, -1, &stmt, NULL)==SQLITE_OK) {
			
			while (sqlite3_step(stmt) == SQLITE_ROW) {
				
				//NSString *str = [NSString stringWithUTF8String:(char *)sqlite3_column_text(stmt, 1)];
				[theShows addObject:[NSString stringWithUTF8String:(char *)sqlite3_column_text(stmt, 1)]];
				
			}
			
		} else {
			printf( "could not prepare statemnt: %s\n", sqlite3_errmsg(db) );
		}
		
	} else {
		printf( "could not prepare statemnt: %s\n", sqlite3_errmsg(db) );
	}
	
	sqlite3_finalize(stmt);
	sqlite3_free(sqlStmt);
	sqlite3_close(db);
}


#pragma mark -
#pragma mark View lifecycle

- (void)viewDidLoad {
    [super viewDidLoad];

    // Uncomment the following line to display an Edit button in the navigation bar for this view controller.
    // self.navigationItem.rightBarButtonItem = self.editButtonItem;
	[self initDB];
	NSLog(@"Loaded data");
	
	/*
	self.navigationItem.rightBarButtonItem = self.editButtonItem;	
	
	UIBarButtonItem	*backButton = [[UIBarButtonItem alloc] initWithTitle:@"Back" 
																   style:UIBarButtonItemStylePlain target:nil action:nil];
	self.navigationItem.backBarButtonItem = backButton;
	*/
}

- (id)initWithStyle:(UITableViewStyle)style {
	if (self = [super initWithStyle:style]) {
		self.title = @"錄音課程";
		self.navigationItem.backBarButtonItem.title = self.title;					 
	}
	
	return self;
}

/*
- (void)viewWillAppear:(BOOL)animated {
    [super viewWillAppear:animated];
}
*/
/*
- (void)viewDidAppear:(BOOL)animated {
    [super viewDidAppear:animated];
}
*/
/*
- (void)viewWillDisappear:(BOOL)animated {
    [super viewWillDisappear:animated];
}
*/
/*
- (void)viewDidDisappear:(BOOL)animated {
    [super viewDidDisappear:animated];
}
*/
/*
// Override to allow orientations other than the default portrait orientation.
- (BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation {
    // Return YES for supported orientations
    return (interfaceOrientation == UIInterfaceOrientationPortrait);
}
*/


#pragma mark -
#pragma mark Table view data source

- (NSInteger)numberOfSectionsInTableView:(UITableView *)tableView {
    // Return the number of sections.
	return 1;
}


- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section {
    // Return the number of rows in the section.
    return [theShows count];
}


// Customize the appearance of table view cells.
- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath {
    static NSString *CellIdentifier = @"Cell";
    
    UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:CellIdentifier];
    if (cell == nil) {
        cell = [[[UITableViewCell alloc] initWithStyle:UITableViewCellStyleDefault reuseIdentifier:CellIdentifier] autorelease];
    }
    
	// Configure the cell.
	cell.textLabel.text = [theShows objectAtIndex:indexPath.row];
	cell.accessoryType = UITableViewCellAccessoryDisclosureIndicator;

    return cell;
}


/*
// Override to support conditional editing of the table view.
- (BOOL)tableView:(UITableView *)tableView canEditRowAtIndexPath:(NSIndexPath *)indexPath {
    // Return NO if you do not want the specified item to be editable.
    return YES;
}
*/


/*
// Override to support editing the table view.
- (void)tableView:(UITableView *)tableView commitEditingStyle:(UITableViewCellEditingStyle)editingStyle forRowAtIndexPath:(NSIndexPath *)indexPath {
    
    if (editingStyle == UITableViewCellEditingStyleDelete) {
        // Delete the row from the data source
        [tableView deleteRowsAtIndexPaths:[NSArray arrayWithObject:indexPath] withRowAnimation:YES];
    }   
    else if (editingStyle == UITableViewCellEditingStyleInsert) {
        // Create a new instance of the appropriate class, insert it into the array, and add a new row to the table view
    }   
}
*/


// Override to support rearranging the table view.
- (void)tableView:(UITableView *)tableView moveRowAtIndexPath:(NSIndexPath *)fromIndexPath toIndexPath:(NSIndexPath *)toIndexPath {
	NSString *title = [theShows objectAtIndex:[fromIndexPath row]];
	[theShows removeObjectAtIndex:[fromIndexPath row]];
	[theShows insertObject:title atIndex:[toIndexPath row]];
}


/*
// Override to support conditional rearranging of the table view.
- (BOOL)tableView:(UITableView *)tableView canMoveRowAtIndexPath:(NSIndexPath *)indexPath {
    // Return NO if you do not want the item to be re-orderable.
    return YES;
}
*/


#pragma mark -
#pragma mark Table view delegate

- (void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath {
    // Navigation logic may go here. Create and push another view controller.
	/*
	 <#DetailViewController#> *detailViewController = [[<#DetailViewController#> alloc] initWithNibName:@"<#Nib name#>" bundle:nil];
     // ...
     // Pass the selected object to the new view controller.
	 [self.navigationController pushViewController:detailViewController animated:YES];
	 [detailViewController release];
	 */
	
	NSLog(@"didSelectRowAtIndexPath");
	Tryit *try = [[Tryit alloc] init];
	[self.parentViewController.navigationController pushViewController:try animated:YES];
	[try release];
}


#pragma mark -
#pragma mark Memory management

- (void)didReceiveMemoryWarning {
    // Releases the view if it doesn't have a superview.
    [super didReceiveMemoryWarning];
    
    // Relinquish ownership any cached data, images, etc that aren't in use.
}

- (void)viewDidUnload {
    // Relinquish ownership of anything that can be recreated in viewDidLoad or on demand.
    // For example: self.myOutlet = nil;
}


- (void)dealloc {
	[theShows release];
    [super dealloc];
}


@end

